BEGIN TRANSACTION ALTER TABLE dbo.Invoice_PURitem ADD RateType varchar(30) NOT NULL CONSTRAINT DF_Invoice_PURitem_RateType DEFAULT 'Per Kg', DlrAmount numeric(15, 4) NOT NULL CONSTRAINT DF_Invoice_PURitem_DlrAmount DEFAULT 0 GO COMMIT